
<!DOCTYPE html>

<html>
    <head>
        <meta name="renderer" content="webkit"> 
        <meta http-equiv="X-UA-Compatible" content="IE=Edge">
        <meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
        <link rel="shortcut icon" href="./favicon.ico" type="image/x-icon">
        <link rel="icon" href="./favicon.ico" type="image/x-icon">
        <title>签亿国际</title> 
        <meta name="Keywords" content="3" />
        <meta name="Description" content="" />
        <link href="css/main.css" rel="stylesheet" type="text/css"/>
        <link href="css/main.show.css" rel="stylesheet" type="text/css"/>
        <script type="text/javascript" src="js/jquery.js"></script>
        <script type="text/javascript" src="js/jquery.cookie.js"></script>
        <script  type="text/javascript" src="js/jquery.hide.js"></script>
        <script type="text/javascript" src="js/jquery.mousewheel.min.js"></script>        
        <link href="css/main.css" rel="stylesheet" type="text/css"/>
        <link href="css/list.main.css" rel="stylesheet" type="text/css"/>
        <link href="css/tell.main.css" rel="stylesheet" type="text/css"/>
        <link rel="stylesheet" href="css/liMarquee.css">
        <script type="text/javascript" src="js/jquery.list.nav.js"></script>
        <script src="js/jquery.liMarquee.js"></script>
</head>

<body>
	<?php 
		$keyword = $_GET['keywords'];
		$nav = 0;
		include_once 'include/header.php';
		include_once 'function.php';
		
		//$showrow = 10; //一页显示的行数 
		//$curpage = empty($_GET['page']) ? 1 : $_GET['page']; //当前的页,还应该处理非数字的情况
		
		$sql = "select a.* from product a left join country b on a.country_id=b.id 
			left join contient c on b.contient_id=c.id ";
		if(!empty($keyword)) {
			$sql = $sql."where a.name like '%$keyword%' or a.ext_name like '%$keyword%' 
				or a.location like '%$keyword%' or a.need_interview like '%$keyword%' or
				a.use_day like '%$keyword%' or a.in_time like '%$keyword%' 
				or a.valid_day like '%$keyword%' or a.max_stay_day like '%$keyword%' or
				a.scope like '%$keyword%'  or a.tip like '%$keyword%' 
				or b.name like '%$keyword%' or c.name like '%$keyword%'";
		}
		$products = getBySQL($sql);
	?>
	<div id="list_main">
		<div class="cut"></div>
		<div class="list_main_show">
		<div style="clear:both"></div> 
		<?php 
			include_once 'include/countrynavicat.php';
		?>
		<div class="newline"></div>
		<div class="list_content_show">
			<div class="list_content_show_left">
				<div class="list_content_left_top">
					<div class="list_content_left_top_title">
						全部商品
						<div class="roll-wrap" id="roll-wrap"><ul></ul></div>                             
					</div>
					<script type="text/javascript">
						new scrollTxt().init();
					</script>
					<div class="list_content_left_top_show">
					<?php 
					foreach ($products as $pd) {
						echo <<< LABEL
										<div class="list_content_country">
											<a href="product.php?id=$pd[id]" target="_blank">
												<div class="list_content_country_left">
													<img src="img/product/icon/$pd[icon]" height=130px width=200px>
													<div class="list_content_country_left_text">
														<h1>$pd[name]<span>【$pd[ext_name]】</span></h1>
														<h3>办理地点： <span>$pd[location]</span></h3>
														<h4>办理时长：<span>$pd[use_day]</span></h4>
														<h5>温馨提示：<span>$pd[tip]</span></h5>
														<h5>最多停留：<span>$pd[max_stay_day]</span></h5>
													</div>
												</div>
												<div class="list_content_country_right">
													<div class="list_content_country_right_div">
														<div class="list_content_country_right_price">
														<span>￥</span>$pd[price]
														</div>
														<div class="list_content_country_right_btn">查看资料</div>
													</div>
													<div class="list_content_country_right_percent">
													出签成功率：<span>$pd[pass_rate]</span>
													</div>
												</div>
											</a>
										</div>
LABEL;
					}
					?>
					</div>
				</div>
			</div>
			<?php 
				include_once 'include/contentright.php';
			?>                 
			<div class="newline"></div>
			<div class="newline"></div>
			<?php 
				include_once 'include/advantage.php';
			?>
             </div>
        </div>
		<div class="newline"></div>
		<div style="clear:both"></div> 

        <div style="clear:both"></div> 
        <?php 
        	include_once 'include/footer.php';
        ?>
        
    </body>

</html>